
[dbo].[BAEPostUpdateWrapup]
create procedure [dbo].[BAEPostUpdateWrapup] @userID varchar(10),
@birthDate varchar(20),
@excludeMail bit,
@SICCode varchar(10) as
IF(@birthDate <> '')
BEGIN
UPDATE Name
SET BIRTH_DATE = @birthDate, EXCLUDE_MAIL = @excludeMail, SIC_CODE = @SICCode
WHERE ID = @userID;
END
ELSE
BEGIN
UPDATE Name
SET BIRTH_DATE = NULL, EXCLUDE_MAIL = @excludeMail, SIC_CODE = @SICCode
WHERE ID = @userID;
END
GO